| |
32 Search Results Found |
| 1 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 03 February 2020 10:29 «»
By: mgarret40
Combining multiple regexp_like statements & correct regex syntax
…")
("Men > Bottoms > Suits, Sport Coats & Trousers")
("Women > Tops > Sweaters")
("Kids > Accessories > Boy's Accessories > Bags")
("boys>accessories>socks")
("Blue_Look…
|
| 2 |
Forum: Reports & Discoverer «»
Posted on: Fri, 03 October 2014 04:24 «»
By: cookiemonster
Re: Rank/Position Calculation.
…you would probably find it a lot easier to sport mistakes
2) This bit is what's probably throwing the error:
(select percentage,rank() over (partition by class order by stuid) AS pos
from (select percentage sum(obtmarks)/sum(totmarks)*100
…
|
| 3 |
Forum: General «»
Posted on: Wed, 18 June 2014 12:00 «»
By: Lalit Kumar B
Re: Good Oracle technical blogs/posts/URLs
…his blog here Learning is not a spectator sport.
You have seen him answering to questions posted at OTN forums, recently he has started volunteering in OraFAQ too. His blog posts have been really amazing the way he writes about the common bad practices/…
|
| 4 |
Forum: Reports & Discoverer «»
Posted on: Tue, 17 June 2014 09:37 «»
By: irfankundi786@yahoo.com
Oracle Report issue
…is detail about the student qualification,sport etc now i want to print each student from starter.means if one student data is print upto 2 and half page the data of second student should start from begin of next page not from midle of second page…
|
| 5 |
Forum: Performance Tuning «»
Posted on: Fri, 21 March 2014 09:18 «»
By: cookiemonster
Re: statement with big cost
…query doesn't return anything in the same sport (never mind ballpark) as 32,000,000,000,000,000 rows.
I wouldn't worry about it. I'm pretty sure that the way the xml functions are implemented means that the optimizer doesn't really have any options when …
|
| 6 |
Forum: Community Hangout «»
Posted on: Mon, 22 April 2013 14:51 «»
By: John Watson
Re: Boston
…t, and the MIT museum looks essential for a dweeb like me. I don't think I'll try any sport (cricket is a mystery to me, so I'ld have no chance with baseball) but some music would be nice. I have more than a feeling that there should be something there…
|
| 7 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 22 March 2012 19:43 «»
By: Barbara Boehmer
Re: SQL Query Help
… 2 1
2 SPORT 2
45 BASEBALL 1 2
22 RUGBY 2 2
6 rows selected.
-- simple hierarchical query using "order siblings by…
|
| 8 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 22 March 2012 13:39 «»
By: Michel Cadot
Re: SQL Query Help
…
4 connect by prior id = parentid
5 order by "Path"
6 /
NAME
----------
FRUIT
ORANGE
MANGO
SPORT
BASEBALL
RUGBY
Nice idea (while there is less than 10 elements in a category but there are workarounds).
Regards
Michel…
|
| 9 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 22 March 2012 13:03 «»
By: Michel Cadot
Re: SQL Query Help
… 1
RUGBY 2 SPORT 2
BASEBALL 1 SPORT 2
Then use this result to build yours:
SQL> with
2 data as (
3 select c.name, c.sortorder, p.name parent, p.sortorder …
|
| 10 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 22 March 2012 11:12 «»
By: Keen2Learn
SQL Query Help
…----------------------------
1 FRUIT 1
2 SPORT 2
12 ORANGE 1 1
22 RUGBY 2 2
23 MANGO 2 1
45 BASEBALL 1 2
For parent FRUIT, we have two child records ORANGE and MANGO and for parent SPORT, we have two child records RUGBY and …
|
| 11 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 07 December 2011 00:26 «»
By: sandy_bridge_655k
Procedure issue
…esperson_id,credit_limit) VALUES
(100,'JOCKSPORTS','345 VIEWRIDGE','BELMONT','CA','96711',
415,5986609,7369,5000);
INSERT INTO CUSTOMER(customer_id,name,address,city,state,zip_code,area_code,
phone_number,salesperson_id,credit_limit) VALUES
(101…
|
| 12 |
Forum: Community Hangout «»
Posted on: Fri, 06 August 2010 13:25 «»
By: Littlefoot
Re: People from down under
... and 12 points for a remark regarding John's visions goes to - BB!
These white lines:
But, soccer requires more lines than these two. I know, it is the most popular sport over here.
|
| 13 |
Forum: Community Hangout «»
Posted on: Fri, 06 August 2010 01:22 «»
By: Littlefoot
Re: People from down under
…that they might be something related to sport activities, but - as I'm unfamiliar with sports played in the US (such as baseball, football ...), no idea whatsoever.
But the lake - it really is narrow. As long as the hospital and House with his team …
|
| 14 |
Forum: SQL & PL/SQL «»
Posted on: Fri, 09 April 2010 01:52 «»
By: Michel Cadot
Re: UNION and UNION ALL
What is best a sport car or a truck?
They don't do the same thing, you can't compare.
Regards
Michel
|
| 15 |
Forum: Performance Tuning «»
Posted on: Thu, 03 December 2009 12:20 «»
By: Frank
Re: Need to tune a Query - xjd
Performance tuning based on (false) assumptions can be a hazardous sport.
|
| 16 |
Forum: Community Hangout «»
Posted on: Thu, 24 September 2009 22:50 «»
By: rleishman
Re: Sports Lovers
…sport, 18 opponents, no off-side (can get hit from behind, or back into a running opponent), no Sin Bin, no padding. I could see how the uneducated might see it that way.
The GF usually contains a bit more biffo than the home-and-away series because …
|
| 17 |
Forum: Community Hangout «»
Posted on: Thu, 24 September 2009 09:53 «»
By: Frank
Re: Sports Lovers
Maybe we are wussies, but from what I have seen from Australian Football, isn't this the main purpose of the sport?
|
| 18 |
Forum: Community Hangout «»
Posted on: Thu, 24 September 2009 09:03 «»
By: rleishman
Sports Lovers
…you love your sport, check out the AFL (Australian Football League) Grand Final tomorrow (about 14:30 GMT+10). It's our Superbowl.
It's been a cracker year and the last two teams at the end of the finals (both Melbourne teams!) were also #1 and #2 at …
|
| 19 |
Forum: Forms «»
Posted on: Sun, 17 May 2009 23:34 «»
By: kris312566
Re: OLE2 PIVOT TABLE
…s("PivotTable1").PivotFields("Sport")
.Orientation = xlRowField
.Position = 1
End With
With ActiveSheet.PivotTables("PivotTable1").PivotFields("Quarter")
.Orientation = …
|
| 20 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 17 January 2007 18:40 «»
By: amankhan
how to skip duplicate records in a procedure from processing
… 500
1196 DAYLE 180 SPORT 800
In my procedure, I need to process only
1128 SMITH 140 MARKT 200
1160 DARON 150 BUSSN 300
1196 DAYLE 180 SPORT 800
only …
|
| 21 |
Forum: SQL & PL/SQL «»
Posted on: Sun, 30 July 2006 17:50 «»
By: William Robertson
Re: NOT EXISTS
… subquery finds anything (i.e. if there are any clients at all in the 'sport' department who have staff assigned to them) then the main query must return no rows.
btw, UNIQUE is valid but DISTINCT is more commonly used in Oracle, if that matters at all…
|
| 22 |
Forum: SQL & PL/SQL «»
Posted on: Fri, 28 July 2006 14:41 «»
By: staann56
NOT EXISTS
…t.Date_dt))) IS NULL
and client.dept = 'sport'
AND NOT EXISTS
(SELECT
NULL
FROM
client,
ccdata.facility,
cpi
WHERE
client.client_num = staff_assign.client_num…
|
| 23 |
Forum: Training & Certification «»
Posted on: Mon, 24 July 2006 05:49 «»
By: albinpaul
Re: Learn "ORACLE CLINICAL"
…i am not good enough.
i am not a spoil sport but an oracle clinical licencing cost queit a lot of money and recently came acors many emails where you can get an oracle clinical licene for as less as 25000,
No I have not great love for oracle but if …
|
| 24 |
Forum: SQL & PL/SQL «»
Posted on: Fri, 21 April 2006 09:40 «»
By: ThomasG
Re: query help please
… help?? (the EVENTNAME is help?)
- in multi sport complex?? (is the complex name "multi" or "multi sport complex" ? There are COMPLEXNAME fields both in event and type, ist that correct? can you post what's the data inside the tables…
|
| 25 |
Forum: SQL & PL/SQL «»
Posted on: Fri, 21 April 2006 09:13 «»
By: oraclenewb
query help please
…"display number of events help in multi sport complex"
i have linked both tables and attempted this following query which i cannot seem to find a problem with
select * from event, type where event.ctypeid = type.ctypeid and complextype = '…
|
| 26 |
Forum: SQL & PL/SQL «»
Posted on: Fri, 18 November 2005 09:57 «»
By: robhulse
Avoiding mutation errors
… 94 01-NOV-05
2 LIC125 Sport001 11-OCT-05 .2 100 01-NOV-05
2 LIC124 Sport001 11-OCT-05 .2 10 01-NOV-05
3 LIC125 Trap001 12-OCT-05 .3 90 01…
|
| 27 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 31 May 2005 13:15 «»
By: claufuente
great problem .... query
…2 normal
usa wdc 5 wolks 1 normal merc 2 sport chev 2 eco
vz ca 20 ford 10 sport merc 5 sport wolks 5 eco
vz ba 6 susuk 4 normal ford 2 station renault 2 normal
vz ci 6 citro 3 normal wolks 2.5 eco chev 0.5 luxe
I need a query for this...
Result…
|
| 28 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 24 May 2005 06:05 «»
By: Fooman
Re: Playing Around with procedure - ORA-00979, ORA-06512
…
SQL> execute AverageQtr('ALL SPORT');
BEGIN AverageQtr('ALL SPORT'); END;
*
ERROR at line 1:
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "USER_NAME.AVERAGEQTR", line 9
ORA-06512: at line 1…
|
| 29 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 24 May 2005 05:05 «»
By: Fooman
Playing Around with procedure - ORA-00979, ORA-06512
… error
SQL> execute AverageQtr ('ALL SPORT');
BEGIN AverageQtr ('ALL SPORT'); END;
*
ERROR at line 1:
ORA-00979: not a GROUP BY expression
ORA-06512: at "USER_NAME.AVERAGEQTR", line 9
ORA-06512: at line 1
My Question is …
|
| 30 |
Forum: Server Utilities «»
Posted on: Fri, 07 May 2004 00:23 «»
By: Hana
Export/Import
…tippmit.dmp LOG=tippmit_exp.log FULL=N OWNER=SPORT ROWS=Y GRANTS=Y INDEXES=Y CONSTRAINTS=Y COMPRESS=N
I want to use a parametr for username, password and connect string - USER/PASSWORD@CONNECTSTRING and for OWNER=SPORT - one script for several users. Pla…
|
| 31 |
Forum: Server Administration «»
Posted on: Thu, 14 August 2003 17:40 «»
By: Daniel
Playing ping pong with ORA-01033
…is written in Centura-Gupta's SAL language and the other is a classic ASP browser page. All of this is on the local host - no remote connections are involved at this stage.
Any help is much appreciated. One-man ping pong is an exhausting sport…
|
| 32 |
Forum: SQL & PL/SQL «»
Posted on: Sat, 27 April 2002 04:09 «»
By: Sid
Re: Expecting trigger to be called explicitly
…-------------- ... ---------
100 JOCKSPORTS ... 7521
101 TKB SPORT SHOP ... 7654
102 VOLLYRITE ... 7521
... ... ...
CREATE TABLE ORD (
ORDID NUMBER (4) NOT NULL,
…
|
Blog
Search
Help
Members
Register
Login
Home